<html>
<!-- =====================================================================

  File:      WhatsNew.htm for Adventure Works Cycles Storefront Sample
  Summary:   Self-documentation for application
  Date:	     June 16, 2003

=====================================================================

  This file is part of the Microsoft SQL Server Code Samples.
  Copyright (C) Microsoft Corporation.  All rights reserved.

This source code is intended only as a supplement to Microsoft
Development Tools and/or on-line documentation.  See these other
materials for detailed information regarding Microsoft code samples.

THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY
KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A
PARTICULAR PURPOSE.

======================================================= -->
    <head>
        <title>Adventure Works Cycles Storefront Documentation</title>
        <link rel="stylesheet" href="style.css">
    </head>
    <body leftmargin="0" topmargin="0" rightmargin="0" bottommargin="0" marginheight="0" marginwidth="0">
        <table cellpadding="10" cellspacing="0" border="0">
            <tr>
                <td colspan="2" class="HeadBg">
                    <span class="Title">Adventure Works Cycles Storefront Documentation</span>
                </td>
            </tr>
            <tr>
                <td rowspan="10">
                    &nbsp;
                </td>
                <td class="Normal" width="98%">
                    <h1>
                        What's New in the Adventure Works Cycles Storefront
                    </h1>
                    <P>
                        The following changes are in this version (Microsoft&reg; SQL Server&trade; 2005) of Adventure Works Cycles Storefront:

                    </P>
                    <UL>
                        <LI>
                            The "Also Bought" upsell control is enhanced to use an OLAP query when OLAP available.
                        </LI>
                        <LI>
                                The storefront has been enhanced to provide backend processing of orders. Once this feature is enabled
                                in the web.config file, when an order is submitted 
                                by the user online, processes such as inventory checking, manufacturing, purchasing and shipping happen 
                                asynchronously 
                                in the backend to fulfill the order using Service Broker. See the readme_orderingservice.htm file in the 
                                installation directory of the Storefront sample for more details.
                        </LI>
                         <LI>
                            All tiers have been upgraded to match the latest Adventure Works Cycles schema, including
                            the new use of several named schemas within the database. 
                        </LI>
                        <LI>
                            ASP.NET 2.0 technology has been incorporated into the sample including adding a master page, 
                            using the login control, and adding a connnectionStrings section to the web.config file.
                        </LI>
                        <LI>
                            Ship to and bill to addresses as well as carrier information is collected during checkout.
                        </LI>
                        <LI>
                            Users can sign up for Adventure Works newsletters and update their customer profile information.
                        </LI>
                    </UL>
                   <P>
                        <h4>Adventure Works Schema</h4>The Adventure Works schema contains tables which represent key business
			aspects of many small, medium, and enterprise scale manufacturing and sales operations. A comprehensive diagram
			of these tables and their relationships is contained in this <A href="Schema.htm">schema diagram</A>. The
			schema contains tables for the following business functions:
			<UL>
				<LI>
					Sales force automation and analysis
				</LI>
				<LI>
				    Customer relationship management
				</LI>
				<LI>
					Human resources
				</LI>
				<LI>
					Purchasing/Vendor (electronic data interchange)
				</LI>
				<LI>
					External facing Web site (Internet)
				</LI>
				<LI>
					Internal facing Web site (Intranet)
				</LI>
				<LI>
					Manufacturing workflow
				</LI>
				<LI>
					Engineering document management
				</LI>
			</UL>
			</P>
			             <P>
                        The following changes were made a previous version of the Adventure Works Cycles Storefront:
                      </P>
                      <UL>                  
                        <li>
                        A page which gathers demographics during the registration process has been added, along with the infrastructure to store the demographics
                        data into the database.  See the <a href="../SourceViewer/srcview.aspx?path=Demographics.src&file=DemographicsPage&rows=5">Demographics Page</A> 
                        for more details.
                        </li>
                        <li>
                        A problem with displaying the user name on the home page has been corrected when the user's name contains
                        certain unicode characters.  The problem has been solved by BASE64 encoding the user's name before it 
                        is stored in a cookie, and also decoding the cookie prior to display.  See <a href="login_aspx_cs.htm">login.aspx</a> 
                        and <a href="default_aspx_cs.htm">default.aspx</a> for implementationd details.
                        </li>
                        <LI>
                                A small WinForms sample application named "ReviewWatcher" is now available. This sample application demonstrates how to
                                use the SqlDependency class to register and process query notifications. Query notifications are a way 
                                for a client application to receive an event when a database table has changed in Microsoft SQL Server.
                                See <A href="../SourceViewer/srcview.aspx?path=QueryNotification.src&file=QueryNotification&rows=3">Using Query Notifications</A>
                                for more details.
                        </LI>
                        <LI>
                                The sample application has been ported to Microsoft&reg; Visual Studio&reg; .NET 2005. As part of this 
                                porting process
                                the tree control for product categories and subcategories are changed from
                                an add-in tree control to one that ships as part of the 2.0 version of ASP.NET.
                        </LI>
                        <LI>
                                The <b>Currency</b> user defined type and the <b>ConvertCurrency</b> user defined function are
                                introduced to move some of the globalization and localization functionality to the server. 
                                The type and function are both implemented as managed (C#) code, and are loaded into and execute 
                                as part of Microsoft SQL Server. This is a new capability and was not available in previous 
                                releases of Microsoft SQL Server.
                        </LI>
		             </UL>
          
			
			    <UL>
			        <li>Adjustment of tables which have rowguids to match what is required for the replication sample, and removal of 
			        the ModifiedDate column. These changes simplify the schema, and
			        reduce the disk footprint for each record, thus improving performance.</li>
			        <li>Changed the identity columns of type tinyint to int. This is required to support replication scenarios.</li>
			    </UL>
			
		                 <UL> 
                            <LI>The reorganization of contact information for employees, vendors, 
                            wholesale customers (stores), and retail customers (individuals). This change provides significantly
                            better normalization and consistency across these areas of the schema.
                            </LI>
                            <LI>The removal of the ProductDescriptionXLocale table. This change removes some complexity from 
                            the schema which makes it easier to understand and use. The same localization of content is still
                            provided for the product descriptions through the ProductModelXProductDescriptionXLocale table.
                            </LI>
                            <LI>
                            The renaming of the ShoppingCart table to ShoppingCartItem. This is done because the table contains
                            items in various shopping carts rather than just a list of shopping carts.
                            </LI>
                        </UL>
                    
                        <h4>Port to Visual Studio .NET 2005</h4>
                        <p>The Adventure
                         Works Cycles Storefront was changed to use the tree control that
                        is provided as part of the standard ASP.NET library included in the .NET Framework 2.0. See the 
                        <A href="../SourceViewer/srcview.aspx?path=Menu.src&file=Menu&rows=4">Menu user control</A> 
			            for more information. Note that, you will need 
                        the .NET Framework runtime (which is included with Microsoft SQL Server 2005) in order to run the sample.
                        You will also need Visual Studio .NET 2005 to browse  solutions, compile, or 
                        debug this version of the sample.
                        
                        
		    </P>
                    
                        <h4>Currency User-defined Type and ConvertCurrency User-defined Function</h4>
                        <P>                       
                        A Currency class and user-defined type were introduced into the Adventure Works Cycles Storefront along with  
                        a ConvertCurrency method and user-defined function. The type and function are used on the server to 
                        greatly simplify the code that handles the conversion of one form of currency to another, and 
                        the correct rendering of that currency using the appropriate currency symbol. This part of the sample 
                        demonstrates how you can write managed code and register that managed code with the server so that it can 
                        be used in server-side data processing. Careful use of this feature of Microsoft SQL Server 2005 
                        can greatly increase the power of user-defined types, functions, and stored procedures, and simplify the 
                        interfaces between the middle and data tiers of your application. It is also possible to greatly improve
                        the performance of your applications using these techniques. See 
                        <A href="../SourceViewer/srcview.aspx?path=CurrencyUDT.src&file=CurrencyUDT&rows=3">Server Side Managed Types and Functions</A>
                         for more details.
                    </P>
                </td>
            </tr>
        </table>
    </body>
</html>


